/**
 * Author : Agero
 * Copyright (c) 2011 Agero.
 * All rights reserved
 */

package com.hoperun.product.dao;

import android.content.UriMatcher;
import android.net.Uri;
import android.provider.BaseColumns;

/**
 * 
 * 
 * @author shen_feng
 * @version 1.0
 * @createDate 2013-3-13
 */
public class MTypeInfoTable implements BaseColumns {

	public static final int TYPEINFO_INFO = Constant_DB.MODULETYPE_FLAG;

	public static final String TABLE_NAME = "typeInfoTable";

	public static final Uri CONTENT_URI = Uri.parse("content://"
			+ Constant_DB.AUTHORITY + "/" + TABLE_NAME);

	// 次品类型：0 修补类型 1
	public static final String MTYPE = "type";

	/**
	 * 类型ID
	 */
	public static final String MID = "id";

	/**
	 * 中文名称
	 */
	public static final String NAME_ZH = "name_zh";

	/**
	 * 越南文名称
	 */
	public static final String NAME_VI = "name_vi";

	public static final String CREATE_TABLE_SQL = "CREATE TABLE IF NOT EXISTS "
			+ TABLE_NAME + "(" + MTypeInfoTable._ID
			+ " INTEGER PRIMARY KEY AUTOINCREMENT," + MTypeInfoTable.MTYPE
			+ " TEXT," + MTypeInfoTable.MID + " TEXT," + MTypeInfoTable.NAME_ZH
			+ " TEXT," + MTypeInfoTable.NAME_VI + " TEXT )";

	/**
	 * the SQL for dropping database
	 */
	public static final String DROP_TABLE_SQL = "DROP TABLE IF EXISTS "
			+ TABLE_NAME;

	public static void getUriMatcherMailInfo(UriMatcher MATHCER) {
		MATHCER.addURI(Constant_DB.AUTHORITY, TABLE_NAME, TYPEINFO_INFO);
	}
}
